﻿CREATE TABLE [dbo].[Issue] (
    [ID]               INT            IDENTITY (1, 1) NOT NULL,
    [IssueKey]         NVARCHAR (50)  NOT NULL,
    [ProjectID]        INT            NOT NULL,
    [ReporterID]       INT            NOT NULL,
    [AssigneeID]       INT            NOT NULL,
    [TypeID]           INT            NOT NULL,
    [Summary]          NVARCHAR (MAX) NOT NULL,
    [Description]      NVARCHAR (MAX) NULL,
    [PriorityID]       INT            NOT NULL,
    [SeverityID]       INT            NULL,
    [ResolutionID]     INT            NULL,
    [StatusID]         INT            NOT NULL,
    [Created]          DATETIME       NULL,
    [Updated]          DATETIME       NULL,
    [Duedate]          DATETIME       NULL,
    [OriginalEstimate] NUMERIC (18)   NULL,
    [StoryPoint]       INT            NULL
);

